Updated at 2025-06-15 10:04:21.899425
Conversion successful! Created: C:/Users/Chris/Python/format_csv.py Before update data summary: Date range: 2011-08-18 to 2025-06-13 Number of rows: 5016 Downloading data from 2025-06-14 to 2025-06-14 After update data summary: Date range: 2011-08-18 to 2025-06-14 Number of rows: 5017 Appended 1 new rows and saved to C:\Users\Chris\Downloads\BITSTAMP_BTCUSD, 1D.csv === CALLING bitcoin_analysis_package === Before update data summary: Date range: 2011-08-18 to 2025-06-14 Number of rows: 5017 CSV is already up to date. After update (unchanged) data summary: Date range: 2011-08-18 to 2025-06-14 Number of rows: 5017 ✅ Complete Bitcoin analysis completed successfully! === FINISHED bitcoin_analysis_package ===
Output folder: C:\Users\Chris\Downloads\btc_report\btc_report_2025-06-15 Success! PDF saved to: C:\Users\Chris\Downloads\btc_report\btc_report_2025-06-15\btc_report_2025-06-15.pdf
1-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | 1 | October | 16.71% | 14.6% | 72.94% | -31.96% | 61.22% | 425 | False | 10.93% | 12.75% | 75% | 124 | 49.98% | 48.73% | 100% | 93 | -4.05% | -4.46% | 33.33% | 93 | 12.82% | 28.54% | 80.87% | 115 |
| 1 | 2 | February | 11.48% | 11.63% | 71.21% | -31.49% | 65.17% | 396 | False | 10.85% | 4.71% | 50% | 116 | 26.93% | 30.1% | 75% | 112 | -5.89% | 1.63% | 66.67% | 84 | 9.11% | 11.06% | 100% | 84 |
| 10 | 3 | November | 40.82% | 11.54% | 65.06% | -37.01% | 450.16% | 415 | False | 24.9% | 25.19% | 100% | 120 | 165.87% | 54.61% | 66.67% | 90 | -13.89% | -16.22% | 33.33% | 90 | 2.39% | 8.8% | 52.17% | 115 |
| 6 | 4 | July | 10.19% | 9.92% | 69.23% | -9.06% | 40.61% | 403 | False | 15.4% | 13.69% | 75% | 124 | 14.7% | 15.83% | 100% | 93 | 9.59% | 16.84% | 66.67% | 93 | -0.68% | -4.06% | 33.33% | 93 |
| 0 | 5 | January | 5.72% | 9.7% | 57.54% | -32.43% | 54.53% | 431 | False | 8.05% | 8.22% | 75% | 124 | 19.57% | 12% | 75% | 124 | -11.31% | -16.74% | 33.33% | 93 | 1.04% | -7.6% | 34.44% | 90 |
| 4 | 6 | May | 9.92% | 7.06% | 57.14% | -35.39% | 70.36% | 434 | False | 11.01% | 10.39% | 100% | 124 | 9.38% | 1.28% | 50% | 124 | 1.75% | -15.61% | 33.33% | 93 | 17.37% | -3.2% | 33.33% | 93 |
| 3 | 7 | April | 11.25% | 5.4% | 64.29% | -17.32% | 46.47% | 420 | False | 7.41% | 5.19% | 75% | 120 | 21.22% | 20.07% | 75% | 120 | 4.94% | -1.31% | 33.33% | 90 | 9.42% | 2.67% | 66.67% | 90 |
| 5 | 8 | June | 1.27% | 2.12% | 55.45% | -37.3% | 27.85% | 404 | True | 10.71% | 11.08% | 50% | 120 | -8.16% | -6.02% | 42.31% | 104 | -16.65% | -14.77% | 33.33% | 90 | 17.51% | 14.67% | 100% | 90 |
| 2 | 9 | March | 12.27% | -1.96% | 42.86% | -32.83% | 186.76% | 434 | False | -3.75% | -3.43% | 25% | 124 | 51.09% | 13.88% | 50% | 124 | -15.03% | -17.57% | 33.33% | 93 | 9.15% | 8.05% | 66.67% | 93 |
| 8 | 10 | September | -4.03% | -3.11% | 36.32% | -39.75% | 19.8% | 413 | False | 6.54% | 6.96% | 75% | 120 | -5.63% | -6.97% | 0% | 90 | -9.14% | -5.96% | 0% | 90 | -9.92% | 2.58% | 53.1% | 113 |
| 11 | 11 | December | 6.64% | -3.2% | 49.65% | -34.61% | 47.15% | 431 | False | 20.26% | 18.54% | 75% | 124 | -4.59% | -18.96% | 33.33% | 93 | -8.45% | -6.98% | 0% | 93 | 12.92% | 12% | 74.38% | 121 |
| 7 | 12 | August | 1.67% | -8.31% | 37.71% | -26.61% | 65.78% | 411 | False | -1.24% | -2.85% | 50% | 124 | 36.78% | 30.92% | 100% | 93 | -13.65% | -13.86% | 0% | 93 | -13% | -11.26% | 0% | 101 |
2-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 1 | November-December | 40.27% | 27.46% | 64.29% | -41.42% | 259.63% | 14 | False | 50.53% | 35.82% | 100% | 4 | 116.89% | 115.72% | 66.67% | 3 | -21.93% | -19.35% | 0% | 3 | 19.18% | 29.92% | 75% | 4 |
| 9 | 2 | October-November | 79.1% | 25.99% | 64.29% | -39.81% | 786.97% | 14 | False | 39.7% | 37.14% | 100% | 4 | 315.63% | 129.95% | 100% | 3 | -18.21% | -11.58% | 0% | 3 | 14.07% | 15.4% | 50% | 4 |
| 8 | 3 | September-October | 11.47% | 18.8% | 71.43% | -58.75% | 59.14% | 14 | False | 16.89% | 18.8% | 100% | 4 | 41.76% | 35.91% | 100% | 3 | -12.45% | -10.16% | 33.33% | 3 | 1.26% | 14.53% | 50% | 4 |
| 3 | 4 | April-May | 23.47% | 17.47% | 64.29% | -36.48% | 114.5% | 14 | False | 18.89% | 16.99% | 75% | 4 | 34.68% | 30.36% | 75% | 4 | 5.33% | 8.17% | 66.67% | 3 | 32.77% | -4.41% | 33.33% | 3 |
| 1 | 5 | February-March | 34.18% | 12.27% | 64.29% | -43.36% | 373.65% | 14 | False | 9.36% | 0.57% | 50% | 4 | 110.7% | 44.28% | 75% | 4 | -18.94% | -31.73% | 33.33% | 3 | 18.37% | 19.99% | 100% | 3 |
| 5 | 6 | June-July | 11.07% | 11.29% | 69.23% | -26.61% | 79.5% | 13 | True | 28.16% | 18.71% | 75% | 4 | 4.16% | 11.29% | 66.67% | 3 | -10.26% | -7.29% | 33.33% | 3 | 16.54% | 18.02% | 100% | 3 |
| 11 | 7 | December-January | 12.6% | 9.48% | 64.29% | -42.33% | 68.2% | 14 | False | 42.35% | 47.52% | 100% | 4 | -19.51% | -28.27% | 33.33% | 3 | -7.21% | -14.04% | 33.33% | 3 | 21.79% | 18.09% | 75% | 4 |
| 4 | 8 | May-June | 14.13% | 5.83% | 69.23% | -47.06% | 104.26% | 13 | False | 23% | 19.82% | 100% | 4 | 2.47% | -35.99% | 33.33% | 3 | -11.73% | -30.92% | 33.33% | 3 | 39.81% | 11.01% | 100% | 3 |
| 0 | 9 | January-February | 18.65% | 5.8% | 64.29% | -25.69% | 153.25% | 14 | False | 18.45% | 14.02% | 100% | 4 | 55.71% | 39.64% | 75% | 4 | -19.04% | -24.85% | 0% | 3 | 7.19% | 2.64% | 66.67% | 3 |
| 2 | 10 | March-April | 27.83% | 1.93% | 64.29% | -18.66% | 317.18% | 14 | False | 0.8% | 0.7% | 75% | 4 | 92.47% | 20.5% | 100% | 4 | -13.99% | -12.91% | 0% | 3 | 19.5% | 26.31% | 66.67% | 3 |
| 6 | 11 | July-August | 13.69% | 0.49% | 53.85% | -25.15% | 92.02% | 13 | False | 15.31% | 10.82% | 50% | 4 | 56.56% | 43.16% | 100% | 3 | -4.92% | 0.49% | 66.67% | 3 | -12.73% | -12.46% | 0% | 3 |
| 7 | 12 | August-September | 0.14% | -5.1% | 30.77% | -32.98% | 51.48% | 13 | False | 5.56% | -2.16% | 25% | 4 | 28.76% | 29.13% | 100% | 3 | -21.39% | -16.59% | 0% | 3 | -14.18% | -17.03% | 0% | 3 |
3-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 1 | November-January | 47.09% | 30.53% | 78.57% | -45.86% | 294.52% | 14 | False | 77.59% | 65.94% | 100% | 4 | 105% | 57.73% | 66.67% | 3 | -22.95% | -35.83% | 33.33% | 3 | 25.69% | 20.64% | 100% | 4 |
| 9 | 2 | October-December | 73.81% | 27.94% | 64.29% | -44.02% | 479.8% | 14 | False | 70.92% | 53.16% | 100% | 4 | 235.36% | 220.84% | 100% | 3 | -25.5% | -17.6% | 0% | 3 | 30.04% | 25.57% | 50% | 4 |
| 8 | 3 | September-November | 74.26% | 25.94% | 64.29% | -60.13% | 775.53% | 14 | False | 46.1% | 46.78% | 100% | 4 | 302.19% | 110.12% | 100% | 3 | -26.35% | -21.29% | 0% | 3 | 6.92% | 12.09% | 50% | 4 |
| 4 | 4 | May-July | 23.52% | 20.24% | 61.54% | -38.04% | 111.72% | 13 | False | 41.29% | 35.36% | 100% | 4 | 17.93% | -28.21% | 33.33% | 3 | -8.28% | -16.42% | 33.33% | 3 | 37.2% | 20.24% | 66.67% | 3 |
| 1 | 5 | February-April | 55.46% | 15% | 57.14% | -44.1% | 589.06% | 14 | False | 11.74% | 7.03% | 50% | 4 | 173.9% | 57.28% | 75% | 4 | -18.41% | -8.94% | 0% | 3 | 29.68% | 26.37% | 100% | 3 |
| 11 | 6 | December-February | 29.23% | 14.17% | 64.29% | -50.86% | 170.62% | 14 | False | 87.04% | 95.07% | 75% | 4 | -23.75% | -24.28% | 33.33% | 3 | -0.78% | -4.51% | 33.33% | 3 | 33.66% | 29.88% | 100% | 4 |
| 2 | 7 | March-May | 37.2% | 12.29% | 71.43% | -27.37% | 281.48% | 14 | False | 11.63% | 10.57% | 100% | 4 | 95.25% | 58.51% | 75% | 4 | -13.37% | -26.51% | 33.33% | 3 | 44.46% | 17.6% | 66.67% | 3 |
| 7 | 8 | August-October | 22.15% | 11.97% | 69.23% | -42.08% | 125.3% | 13 | False | 15.21% | 15.25% | 100% | 4 | 93.79% | 108.18% | 100% | 3 | -24.16% | -18.42% | 0% | 3 | 6.07% | 8.95% | 66.67% | 3 |
| 3 | 9 | April-June | 28.02% | 7.61% | 61.54% | -56.23% | 162.95% | 13 | False | 31.56% | 38.62% | 75% | 4 | 27.83% | -6.25% | 33.33% | 3 | -7.69% | -7.81% | 33.33% | 3 | 59.19% | 7.61% | 100% | 3 |
| 0 | 10 | January-March | 54.24% | 2.72% | 50% | -50.08% | 626.21% | 14 | False | 15.4% | 1.61% | 50% | 4 | 182.02% | 56.73% | 75% | 4 | -29.83% | -37.86% | 0% | 3 | 19.75% | 10.89% | 66.67% | 3 |
| 6 | 11 | July-September | 11.88% | 1% | 53.85% | -38.89% | 85.15% | 13 | False | 23.85% | 9.48% | 75% | 4 | 47.23% | 41.2% | 100% | 3 | -12.75% | -2.68% | 33.33% | 3 | -14.8% | -11.5% | 0% | 3 |
| 5 | 12 | June-August | 14.48% | 0.42% | 61.54% | -36.88% | 106.02% | 13 | True | 28.62% | 15.31% | 75% | 4 | 44.23% | 26.49% | 100% | 3 | -22.3% | -23.7% | 0% | 3 | 2.65% | 0.42% | 66.67% | 3 |
6-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | 1 | September-February | 86.19% | 66.01% | 64.29% | -47.08% | 330.1% | 14 | False | 167.12% | 168.72% | 100% | 4 | 146.54% | 117.88% | 66.67% | 3 | -25.88% | -45.96% | 33.33% | 3 | 44.05% | 38.96% | 50% | 4 |
| 9 | 2 | October-March | 125.23% | 53.4% | 78.57% | -37.92% | 687.47% | 14 | False | 309.75% | 260.61% | 100% | 4 | 108.09% | 60.16% | 100% | 3 | -9.53% | -37.3% | 33.33% | 3 | 54.63% | 38.42% | 75% | 4 |
| 7 | 3 | August-January | 103.32% | 45.64% | 61.54% | -62.83% | 721.32% | 13 | False | 106.41% | 89.49% | 100% | 4 | 323.16% | 255.38% | 66.67% | 3 | -39.78% | -55.83% | 0% | 3 | 22.49% | 29.44% | 66.67% | 3 |
| 11 | 4 | December-May | 104.03% | 45.3% | 71.43% | -44.3% | 932.36% | 14 | False | 310.01% | 149.6% | 100% | 4 | -37.58% | -43.92% | 0% | 3 | 44.9% | 58.56% | 66.67% | 3 | 48.6% | 45.3% | 100% | 4 |
| 6 | 5 | July-December | 121.97% | 45.02% | 69.23% | -49.84% | 718.7% | 13 | False | 102.98% | 74.8% | 100% | 4 | 404.5% | 462.97% | 100% | 3 | -36.4% | -42.16% | 0% | 3 | 23.14% | 38.69% | 66.67% | 3 |
| 0 | 6 | January-June | 81.65% | 44.32% | 69.23% | -56.9% | 576.21% | 13 | False | 43.8% | 46.32% | 100% | 4 | 250.72% | 155.14% | 100% | 3 | -41.1% | -53.99% | 0% | 3 | 85.8% | 84.33% | 66.67% | 3 |
| 10 | 7 | November-April | 135.98% | 43.93% | 71.43% | -38.65% | 1171.64% | 14 | False | 404.54% | 206.19% | 100% | 4 | 41.84% | 43.64% | 66.67% | 3 | -1.29% | -16.42% | 33.33% | 3 | 40.98% | 47.41% | 75% | 4 |
| 5 | 8 | June-November | 111.69% | 42.85% | 69.23% | -47% | 776.49% | 13 | True | 82.81% | 75.72% | 100% | 4 | 387.4% | 332.88% | 100% | 3 | -44.3% | -45.97% | 0% | 3 | 30.5% | 38.57% | 66.67% | 3 |
| 4 | 9 | May-October | 54.16% | 31.17% | 76.92% | -45.54% | 377% | 13 | False | 63.52% | 57.77% | 100% | 4 | 142.9% | 45.52% | 100% | 3 | -34.02% | -31.81% | 0% | 3 | 41.12% | 31.17% | 100% | 3 |
| 1 | 10 | February-July | 75.2% | 30.4% | 76.92% | -39.4% | 384.14% | 13 | False | 52.64% | 59.83% | 100% | 4 | 201.9% | 196.25% | 100% | 3 | -30.26% | -27.52% | 0% | 3 | 84.07% | 30.4% | 100% | 3 |
| 2 | 11 | March-August | 62.14% | 12.04% | 61.54% | -53.59% | 297.45% | 13 | False | 41.85% | 33.7% | 75% | 4 | 194.46% | 281.75% | 100% | 3 | -32.92% | -31.97% | 0% | 3 | 51.93% | 12.04% | 66.67% | 3 |
| 3 | 12 | April-September | 44.76% | -3.17% | 46.15% | -57.33% | 303.8% | 13 | False | 63.26% | 57.17% | 75% | 4 | 103.52% | 32.2% | 66.67% | 3 | -25.36% | -14.01% | 0% | 3 | 31.44% | -3.17% | 33.33% | 3 |
Analysis includes data from 14 years: 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024 Historical Year-End Returns (Full Year): 2013 (Cycle Year 1): +5437.07% 2017 (Cycle Year 1): +1291.13% 2020 (Cycle Year 4): +303.87% 2012 (Cycle Year 4): +164.80% 2023 (Cycle Year 3): +154.34% 2016 (Cycle Year 4): +122.74% 2024 (Cycle Year 4): +111.33% 2019 (Cycle Year 3): +87.48% 2021 (Cycle Year 1): +57.18% 2015 (Cycle Year 3): +37.31% 2014 (Cycle Year 2): -57.44% 2011 (Cycle Year 3): -57.98% 2022 (Cycle Year 2): -65.41% 2018 (Cycle Year 2): -72.53% Average Year-End Return: +536.71% Median Year-End Return: +111.33% Returns by Cycle Year: Cycle Year 1 (years: 2013, 2017, 2021): Average: +2261.79% Sample size: 3 years Cycle Year 2 (years: 2014, 2022, 2018): Average: -65.12% Sample size: 3 years Cycle Year 3 (years: 2023, 2019, 2015, 2011): Average: +55.29% Sample size: 4 years Cycle Year 4 (years: 2020, 2012, 2016, 2024): Average: +175.69% Sample size: 4 years
Analysis includes 3 years matching cycle year(s) Year 1: 2013, 2017, 2021 Historical Year-End Returns (Full Year): 2013 (Cycle Year 1): +5437.07% 2017 (Cycle Year 1): +1291.13% 2021 (Cycle Year 1): +57.18% Average Year-End Return (Cycle Year 1): +2261.79% Median Year-End Return (Cycle Year 1): +1291.13% Returns by Cycle Year: Cycle Year 1 (years: 2013, 2017, 2021): Average: +2261.79% Sample size: 3 years
Calculating best fit line from start to end of data...
============================================================ BEST FIT LINE FROM START TO END SUMMARY: ============================================================ Total Data Period: 5017 days R-squared: 0.886634 Scale Type: Log Scale Daily Growth Rate: 0.1830% Annual Growth Rate: 94.93% Historical Performance: Start Price: $10.90 End Price: $105472.41 Total Change: $105461.51 (967536.75%) 1000-Day Projection: Projected Price: $1530973.68 Projected Change: $1425501.27 (1351.54%) Valuation Oscillator Summary: Current Deviation: -57.11% Max Overvaluation: 1063.74% Max Undervaluation: -92.25% 🟢 Currently UNDERVALUED relative to long-term trend
Finding top 3 best fitting linear regression channels for BTC (log scale)... Top 3 Best Fitting Linear Regression Channels (Log Scale): ================================================================================ 1. Window Size: 1000 days R-squared: 0.935980 Daily Growth Rate: 0.1947% Annual Growth Rate: 103.37% Price Change: $85934.41 (439.83%) Start Price: $19538.00 End Price: $105472.41 2. Window Size: 750 days R-squared: 0.882893 Daily Growth Rate: 0.1968% Annual Growth Rate: 104.96% Price Change: $78600.41 (292.50%) Start Price: $26872.00 End Price: $105472.41 3. Window Size: 90 days R-squared: 0.825623 Daily Growth Rate: 0.3821% Annual Growth Rate: 302.32% Price Change: $21414.41 (25.48%) Start Price: $84058.00 End Price: $105472.41 Plotting the top 3 regression channels with adaptive projections... (Windows ≤100 days: +30d projection, Windows >100 days: +180d projection)
Results stored in 'top_channels' variable
============================================================
SUMMARY - TOP 3 BEST FITTING CHANNELS:
============================================================
#1. 1000 days | R² = 0.935980
Annual Growth: 103.37%
Price Range: $19538 → $105472 (439.8%)
PRICE PROJECTIONS:
+30 days: $124,785 ($93,488 - $166,558)
+60 days: $132,282 ($99,100 - $176,574)
+90 days: $140,229 ($105,047 - $187,194)
#2. 750 days | R² = 0.882893
Annual Growth: 104.96%
Price Range: $26872 → $105472 (292.5%)
PRICE PROJECTIONS:
+30 days: $125,482 ($92,472 - $170,276)
+60 days: $133,106 ($98,080 - $180,642)
+90 days: $141,194 ($104,027 - $191,639)
#3. 90 days | R² = 0.825623
Annual Growth: 302.32%
Price Range: $84058 → $105472 (25.5%)
PRICE PROJECTIONS:
+30 days: $125,705 ($114,311 - $138,235)
+60 days: $140,943 ($127,690 - $155,572)
+90 days: $158,029 ($142,486 - $175,267)
========================================================================================================================
MONTE CARLO SIMULATION SUMMARY TABLE
========================================================================================================================
Method Median Risk/ 99% > 95% > 75% > Median 75% < 95% < 99% <
Name Change Reward Above Above Above Price Below Below Below
------------------------------------------------------------------------------------------------------------------------
Standard GBM (Normal) +22.9% 3.8:1 $49,084 $66,144 $98,649 $129,652 $171,403 $255,853 $339,294
Fat Tails (Student-t) +9.5% 2.1:1 $-9,801 $43,640 $84,522 $115,467 $154,630 $237,268 $335,778
Skewed Normal +27.0% 4.3:1 $58,294 $74,280 $104,827 $133,963 $169,830 $238,724 $301,371
Historical Bootstrap +23.9% 3.5:1 $47,604 $65,312 $99,905 $130,723 $170,040 $247,306 $324,077
Mixed (Bootstrap + Extremes) +21.0% 2.9:1 $18,936 $52,364 $93,593 $127,639 $169,136 $257,376 $356,674
------------------------------------------------------------------------------------------------------------------------
AVERAGE ACROSS METHODS +20.9% 3.3:1 $32,823 $60,348 $96,299 $127,489 $167,008 $247,305 $331,439
MEDIAN ACROSS METHODS +22.9% 3.5:1 $47,604 $65,312 $98,649 $129,652 $169,830 $247,306 $335,778
========================================================================================================================
🎯 CONSENSUS FORECAST (Average of All Methods):
• Expected Return (90 days): +20.9%
• Target Price: $127,489
• Risk/Reward Ratio: 3.3:1
• 95% Confidence Range: $60,348 to $247,305
• Extreme Downside (5% chance): Below $60,348 (-42.8%)
• Extreme Upside (5% chance): Above $247,305 (+134.5%)
• 📈 Probability of Profit: 67.9% chance of making money
• 📉 Probability of Loss: 32.1% chance of losing money
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (90 Days)
Method: Fat Tails (Student-t)
================================================================================
Median outcome: +9.5% change
Risk/Reward ratio: 2.1:1
→ 99% chance Bitcoin will be ABOVE $-9,801
→ 95% chance Bitcoin will be ABOVE $43,640
→ 75% chance Bitcoin will be ABOVE $84,522
→ Median value in 90 days $115,467
→ 75% chance Bitcoin will be BELOW $154,630
→ 95% chance Bitcoin will be BELOW $237,268
→ 99% chance Bitcoin will be BELOW $335,778
================================================================================
→ VaR (5%): $43,640 (-58.6%)
→ VaR (1%): $-9,801 (-109.3%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (90 Days)
Method: Mixed (Bootstrap + Extremes)
================================================================================
Median outcome: +21.0% change
Risk/Reward ratio: 2.9:1
→ 99% chance Bitcoin will be ABOVE $18,936
→ 95% chance Bitcoin will be ABOVE $52,364
→ 75% chance Bitcoin will be ABOVE $93,593
→ Median value in 90 days $127,639
→ 75% chance Bitcoin will be BELOW $169,136
→ 95% chance Bitcoin will be BELOW $257,376
→ 99% chance Bitcoin will be BELOW $356,674
================================================================================
→ VaR (5%): $52,364 (-50.4%)
→ VaR (1%): $18,936 (-82.0%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
========================================================================================================================
MONTE CARLO SIMULATION SUMMARY TABLE
========================================================================================================================
Method Median Risk/ 99% > 95% > 75% > Median 75% < 95% < 99% <
Name Change Reward Above Above Above Price Below Below Below
------------------------------------------------------------------------------------------------------------------------
Standard GBM (Normal) +58.2% 7.8:1 $41,904 $61,433 $112,288 $166,805 $248,903 $449,026 $646,330
Fat Tails (Student-t) +19.3% 3.3:1 $-88,841 $19,691 $75,355 $125,818 $199,134 $388,501 $647,308
Skewed Normal +71.4% 11.1:1 $54,370 $76,911 $128,153 $180,792 $256,761 $422,269 $596,442
Historical Bootstrap +61.0% 7.9:1 $39,664 $61,849 $112,203 $169,852 $253,193 $449,492 $671,326
Mixed (Bootstrap + Extremes) +51.4% 5.0:1 $-13,831 $35,792 $98,051 $159,643 $246,113 $453,439 $728,442
------------------------------------------------------------------------------------------------------------------------
AVERAGE ACROSS METHODS +52.3% 7.0:1 $ 6,653 $51,135 $105,210 $160,582 $240,821 $432,546 $657,970
MEDIAN ACROSS METHODS +58.2% 7.8:1 $39,664 $61,433 $112,203 $166,805 $248,903 $449,026 $647,308
========================================================================================================================
🎯 CONSENSUS FORECAST (Average of All Methods):
• Expected Return (90 days): +52.3%
• Target Price: $160,582
• Risk/Reward Ratio: 7.0:1
• 95% Confidence Range: $51,135 to $432,546
• Extreme Downside (5% chance): Below $51,135 (-51.5%)
• Extreme Upside (5% chance): Above $432,546 (+310.1%)
• 📈 Probability of Profit: 74.6% chance of making money
• 📉 Probability of Loss: 25.4% chance of losing money
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (199 Days)
Method: Fat Tails (Student-t)
================================================================================
Median outcome: +19.3% change
Risk/Reward ratio: 3.3:1
→ 99% chance Bitcoin will be ABOVE $-88,841
→ 95% chance Bitcoin will be ABOVE $19,691
→ 75% chance Bitcoin will be ABOVE $75,355
→ Median value in 199 days $125,818
→ 75% chance Bitcoin will be BELOW $199,134
→ 95% chance Bitcoin will be BELOW $388,501
→ 99% chance Bitcoin will be BELOW $647,308
================================================================================
→ VaR (5%): $19,691 (-81.3%)
→ VaR (1%): $-88,841 (-184.2%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (199 Days)
Method: Mixed (Bootstrap + Extremes)
================================================================================
Median outcome: +51.4% change
Risk/Reward ratio: 5.0:1
→ 99% chance Bitcoin will be ABOVE $-13,831
→ 95% chance Bitcoin will be ABOVE $35,792
→ 75% chance Bitcoin will be ABOVE $98,051
→ Median value in 199 days $159,643
→ 75% chance Bitcoin will be BELOW $246,113
→ 95% chance Bitcoin will be BELOW $453,439
→ 99% chance Bitcoin will be BELOW $728,442
================================================================================
→ VaR (5%): $35,792 (-66.1%)
→ VaR (1%): $-13,831 (-113.1%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
🚀 RUNNING COMPLETE YTD ANALYSIS WITH AUTOMATIC CHART...
=== DATAFRAME PREPARATION ===
Date range: 2011-08-18 00:00:00 to 2025-06-14 00:00:00
Total data points: 5017
Price range: $2.24 to $111673.28
Using 2025 for YTD calculation
========================================================================================================================
ENHANCED DRIFT RATE COMPARISON - HISTORICAL vs YTD
========================================================================================================================
Method Hist Daily Hist Annual % YTD Daily YTD Annual % Difference %
------------------------------------------------------------------------------------------------------------------------
Simple Mean 0.003253 118.72% 0.001037 37.86% -80.86%
Geometric Mean 0.001831 95.00% 0.000768 28.03% -66.96%
Log Returns 0.001830 66.78% 0.001037 37.86% -28.92%
Volatility-Adjusted 0.002336 85.26% 0.000934 34.07% -51.19%
Rolling Window 0.002425 88.51% 0.001037 37.86% -50.65%
Regime-Aware 0.003253 118.72% 0.000768 28.03% -90.69%
SUMMARY STATISTICS:
--------------------------------------------------------------------------------
Metric Historical YTD Difference
--------------------------------------------------------------------------------
Average Annual % 95.50% 33.95% -61.55%
Median Annual % 91.75% 35.97% -55.79%
Std Dev % 18.52% 4.39% -14.12%
🎯 KEY INSIGHTS:
--------------------------------------------------
📉 YTD performance is UNDERPERFORMING historical median
• Historical median: 91.75% annually
• YTD compound annual: 28.03% annually
• Performance gap: -63.72%
📊 MONTE CARLO RECOMMENDATIONS:
--------------------------------------------------
• Conservative (lower): 0.280335 daily (10232.2% annual)
• Aggressive (higher): 0.917532 daily (33489.9% annual)
• Blended (70% hist, 30% YTD): 0.726373 daily (26512.6% annual)
• Historical median: 0.917532 daily (33489.9% annual)
• YTD-based: 0.280335 daily (10232.2% annual)
• Low historical variation allows using either mean or median
================================================================================
🎯 KEY YTD METRICS
================================================================================
📅 YTD Period: 2025-01-01 to 2025-06-14
⏱️ Days Elapsed: 164
📈 YTD Total Return: +11.74%
🎯 YTD Annual Drift: +28.03%
📊 Historical Median: +91.75%
🔄 Difference: -63.72% (UNDERPERFORMING)
📊 GENERATING PERFORMANCE CHART...
📊 CHART SUMMARY: • YTD Period: 2025-01-02 to 2025-06-14 • Current YTD Return: +11.7% • Expected at Benchmark Pace: +41.2% • Performance Gap: -29.5% • Status: UNDERPERFORMING benchmark 💾 SAVE THESE VALUES: ytd_annual_drift = 0.280335 historical_median = 0.917532 performance_gap = -63.72% 📈 Chart generated successfully! • Final YTD return: 11.7% • Final benchmark: 41.2% • Final gap: -29.5%
🎯 MARKET SIMILARITY ANALYSIS - NON-OVERLAPPING VERSION ============================================================ 📊 Calculating market features... 🎯 CURRENT FEATURES ANALYSIS: Days since ATH: 23 % from ATH: -5.80% RSI-14: 49.9 🔍 Finding similar periods... ✅ Found 6 diverse periods 📊 Analyzing top 3 most similar periods 🏆 TOP 3 SIMILAR PERIODS (NON-OVERLAPPING CHARTS) ================================================================================ #1 MATCH (Score: 0.998) - 28 features 📅 Period: 2024-09-05 00:00:00 to 2024-11-04 00:00:00 🔍 Current Signal Date: 2025-06-14 00:00:00 (Today's analysis date) 🔍 Key Comparisons: Days since ATH : Now 23.0 | Then 235.0 | Diff -212.0 % from ATH : Now -5.8 | Then -8.1 | Diff +2.3 30d return : Now 13.3 | Then 5.9 | Diff +7.3 RSI-14 : Now 49.9 | Then 51.3 | Diff -1.4 📈 What happened next: 5d : +13.1% 10d: +28.8% 20d: +44.5% 30d: +45.6% 60d: +44.7% 90d: +44.0%
└─ Non-overlapping chart created for Match #1 ──────────────────────────────────────────────────────────────────────────────── #2 MATCH (Score: 0.997) - 28 features 📅 Period: 2021-07-18 00:00:00 to 2021-09-16 00:00:00 🔍 Current Signal Date: 2025-06-14 00:00:00 (Today's analysis date) 🔍 Key Comparisons: Days since ATH : Now 23.0 | Then 155.0 | Diff -132.0 % from ATH : Now -5.8 | Then -26.4 | Diff +20.6 30d return : Now 13.3 | Then 20.9 | Diff -7.6 RSI-14 : Now 49.9 | Then 52.4 | Diff -2.5 📈 What happened next: 5d : -15.0% 10d: -9.5% 20d: +15.9% 30d: +27.4% 60d: +33.2% 90d: +2.3%
└─ Non-overlapping chart created for Match #2 ──────────────────────────────────────────────────────────────────────────────── #3 MATCH (Score: 0.997) - 28 features 📅 Period: 2021-08-02 00:00:00 to 2021-10-01 00:00:00 🔍 Current Signal Date: 2025-06-14 00:00:00 (Today's analysis date) 🔍 Key Comparisons: Days since ATH : Now 23.0 | Then 170.0 | Diff -147.0 % from ATH : Now -5.8 | Then -25.8 | Diff +20.0 30d return : Now 13.3 | Then 16.9 | Diff -3.6 RSI-14 : Now 49.9 | Then 58.1 | Diff -8.2 📈 What happened next: 5d : +14.9% 10d: +19.3% 20d: +29.2% 30d: +27.4% 60d: +18.3% 90d: -2.1%
└─ Non-overlapping chart created for Match #3
Applying clustering filter with 10-day window... Filtered from 198 to 18 periods Found 5 periods with correlation >= 0.7 Top correlated periods: 1. 2022-09-14 to 2023-02-25 (Year: 2022, Correlation: 0.8699) Extended to: 2023-08-24 (+180 days) 2. 2023-06-20 to 2023-12-01 (Year: 2023, Correlation: 0.8496) Extended to: 2024-05-29 (+180 days) 3. 2013-05-01 to 2013-10-12 (Year: 2013, Correlation: 0.8344) Extended to: 2014-04-10 (+180 days) 4. 2015-06-22 to 2015-12-03 (Year: 2015, Correlation: 0.8327) Extended to: 2016-05-31 (+180 days) 5. 2015-02-17 to 2015-07-31 (Year: 2015, Correlation: 0.8173) Extended to: 2016-01-27 (+180 days)
Detailed correlation results: start_date end_date correlation year period_length extended_length 0 2022-09-14 2023-02-25 0.869863 2022 165 345 1 2023-06-20 2023-12-01 0.849568 2023 165 345 2 2013-05-01 2013-10-12 0.834370 2013 165 345 3 2015-06-22 2015-12-03 0.832694 2015 165 345 4 2015-02-17 2015-07-31 0.817297 2015 165 345 Best match details: Period: 2022-09-14 to 2023-02-25 Correlation: 0.8699
=== CALLING bitcoin_analysis_package ===
Before update data summary:
Date range: 2011-08-18 to 2025-06-14
Number of rows: 5017
CSV is already up to date.
After update (unchanged) data summary:
Date range: 2011-08-18 to 2025-06-14
Number of rows: 5017
✅ Complete Bitcoin analysis completed successfully!
=== FINISHED bitcoin_analysis_package ===
time open high low close daily_return_percent day year year_return_percent cycle_year cycle_year_return_percent quarter quarter_return_percent month monthly_return_percent week weekly_return_percent half_month half_monthly_return_percent
5016 2025-06-14 106108.085938 106203.757812 104379.367188 105472.40625 -0.599087 Saturday 2025 12.989605 Year1 12.989605 2 27.78803 June 0.798099 24 -0.303061 1H_June 0.798099
ORIGINAL ROLLING RETURNS ANALYSIS:
================================================================================
================================================================================ AUTOMATIC FORWARD PERFORMANCE ANALYSIS: ================================================================================ Using 4 similar dates identified above for forward performance analysis FORWARD RETURNS ANALYSIS ================================================================================ Current 30-day return: 0.80% Similar periods threshold: ±0.50% Filters applied: Cycle Years: Year1, Quarters: 2 Total similar periods found: 4 ================================================================================ Forward Returns Summary: ------------------------------------------------------------------------------------------------------------------------ Window Count Median Mean Std Dev 95% CI Lower 95% CI Upper Min Max % Positive ------------------------------------------------------------------------------------------------------------------------ 7 days 4 7.44% 6.85% 6.07% -2.81% 16.50% 0.38% 12.14% 100.0% 14 days 4 3.41% 0.90% 13.72% -20.93% 22.73% -17.97% 14.75% 75.0% 30 days 3 -18.74% -9.28% 31.73% -88.09% 69.54% -35.20% 26.11% 33.3% 90 days 2 16.34% 16.34% 60.90% -530.83% 563.51% -26.73% 59.40% 50.0% 180 days 2 298.33% 298.33% 407.71% -3364.84% 3961.49% 10.03% 586.62% 100.0% 365 days 2 65.79% 65.79% 138.25% -1176.30% 1307.87% -31.97% 163.54% 50.0% Top 5 Similar Periods (with 90-day forward returns): -------------------------------------------------------------------------------- Start Date End Date Forward Return Cycle Year Quarter 2021-05-02 2021-07-31 -26.73% Year1 2 2017-06-15 2017-09-13 59.40% Year1 2 ================================================================================ Dates with sufficient 14-day forward data for chart: 4 Showing forward performance chart for these 4 periods: 1. 2017-06-15 2. 2021-05-02 3. 2025-04-18 4. 2025-05-30
ORIGINAL ROLLING RETURNS ANALYSIS: ================================================================================
================================================================================ AUTOMATIC FORWARD PERFORMANCE ANALYSIS: ================================================================================ Using 3 similar dates identified above for forward performance analysis FORWARD RETURNS ANALYSIS ================================================================================ Current 30-day return: 1.62% Similar periods threshold: ±0.50% Filters applied: Cycle Years: Year1, Quarters: 2 Total similar periods found: 3 ================================================================================ Forward Returns Summary: ------------------------------------------------------------------------------------------------------------------------ Window Count Median Mean Std Dev 95% CI Lower 95% CI Upper Min Max % Positive ------------------------------------------------------------------------------------------------------------------------ 7 days 3 10.06% 0.32% 18.32% -45.18% 45.82% -20.81% 11.70% 66.7% 14 days 3 10.70% -4.35% 27.79% -73.39% 64.69% -36.42% 12.67% 66.7% 30 days 3 24.03% 2.13% 39.14% -95.11% 99.37% -43.07% 25.42% 66.7% 90 days 1 -27.34% -27.34% nan% nan% nan% -27.34% -27.34% 0.0% 180 days 1 4.19% 4.19% nan% nan% nan% 4.19% 4.19% 100.0% 365 days 1 -42.31% -42.31% nan% nan% nan% -42.31% -42.31% 0.0% Top 5 Similar Periods (with 90-day forward returns): -------------------------------------------------------------------------------- Start Date End Date Forward Return Cycle Year Quarter 2021-05-08 2021-08-06 -27.34% Year1 2 ================================================================================ Dates with sufficient 30-day forward data for chart: 3 Showing forward performance chart for these 3 periods: 1. 2021-05-08 2. 2025-04-15 3. 2025-04-20
ORIGINAL ROLLING RETURNS ANALYSIS: ================================================================================
================================================================================ AUTOMATIC FORWARD PERFORMANCE ANALYSIS: ================================================================================ Using 1 similar dates identified above for forward performance analysis FORWARD RETURNS ANALYSIS ================================================================================ Current 30-day return: 27.76% Similar periods threshold: ±0.50% Filters applied: Cycle Years: Year1, Quarters: 2 Total similar periods found: 1 ================================================================================ Forward Returns Summary: ------------------------------------------------------------------------------------------------------------------------ Window Count Median Mean Std Dev 95% CI Lower 95% CI Upper Min Max % Positive ------------------------------------------------------------------------------------------------------------------------ 7 days 1 -2.85% -2.85% nan% nan% nan% -2.85% -2.85% 0.0% 14 days 1 0.82% 0.82% nan% nan% nan% 0.82% 0.82% 100.0% 30 days 0 N/A N/A N/A N/A N/A N/A N/A N/A 90 days 0 N/A N/A N/A N/A N/A N/A N/A N/A 180 days 0 N/A N/A N/A N/A N/A N/A N/A N/A 365 days 0 N/A N/A N/A N/A N/A N/A N/A N/A Top 5 Similar Periods (with 90-day forward returns): -------------------------------------------------------------------------------- Start Date End Date Forward Return Cycle Year Quarter ================================================================================ Dates with sufficient 90-day forward data for chart: 0 No dates have sufficient 90-day forward data for performance chart. Try reducing 'forward_days' parameter or check data availability.
===== Bitcoin 50% Recovery Points from 30%+ Drawdowns in 2024-2025 ===== Total recovery points found: 2 ----- Average Statistics ----- Average Drawdown: 32.4% Average Forward Returns: 7 days: -2.9% (Win rate: 50.0%) 14 days: 0.7% (Win rate: 50.0%) 30 days: 3.6% (Win rate: 50.0%) 60 days: 0.8% (Win rate: 100.0%) 90 days: 22.6% (Win rate: 100.0%) 180 days: 58.5% (Win rate: 100.0%)
===== Bitcoin 50% Recovery Points from 30%+ Drawdowns Cycle Year(s): Year1 ===== Total recovery points found: 14 Showing 3 out of 14 recovery points (sorted by drawdown size) Recovery Point #1 (sorted by drawdown size): Date: 2013-10-18 00:00:00 Year: 2013 | Cycle_year: Year1 | Quarter: 4 | Month: October Price at recovery: $152.89 Previous peak (high): $259.34 Drawdown low: $45.00 Drawdown amount: $214.34 (82.6%) Recovery amount: $107.89 (50.3%) Forward Returns: 7d: 22.0% | 14d: 32.2% | 30d: 212.2% | 60d: 341.5% | 90d: 444.1% | 180d: 660.2% Recovery Point #2 (sorted by drawdown size): Date: 2017-01-01 00:00:00 Year: 2017 | Cycle_year: Year1 | Quarter: 1 | Month: January Price at recovery: $997.75 Previous peak (high): $1163.00 Drawdown low: $382.21 Drawdown amount: $780.79 (67.1%) Recovery amount: $615.54 (78.8%) Forward Returns: 7d: -8.8% | 14d: -17.6% | 30d: -3.4% | 60d: 26.0% | 90d: 8.6% | 180d: 147.1% Recovery Point #3 (sorted by drawdown size): Date: 2021-08-13 00:00:00 Year: 2021 | Cycle_year: Year1 | Quarter: 3 | Month: August Price at recovery: $47860.58 Previous peak (high): $64895.22 Drawdown low: $28600.00 Drawdown amount: $36295.22 (55.9%) Recovery amount: $19260.58 (53.1%) Forward Returns: 7d: 3.1% | 14d: 2.6% | 30d: -3.8% | 60d: 17.0% | 90d: 35.4% | 180d: 101.6% ----- Average Statistics ----- Average Drawdown: 43.6% Average Forward Returns: 7 days: 13.0% (Win rate: 64.3%) 14 days: 25.3% (Win rate: 71.4%) 30 days: 57.4% (Win rate: 71.4%) 60 days: 91.7% (Win rate: 92.3%) 90 days: 135.9% (Win rate: 100.0%) 180 days: 364.6% (Win rate: 100.0%)
🎯 COMPLETE ANALYSIS FOR Year1
============================================================
🔄 Calculating days since 20-day highs/lows...
📊 CURRENT STATUS (20-DAY WINDOW):
Days since 20-day high: 18
Days since 20-day low: 9
20-day high: $110744.21
20-day low: $100436.88
Current close: $105472.41
Current cycle year: Year1
Current month: June
Current quarter: Q2
------------------------------------------------------------
🧪 HISTORICAL TESTING - 20-DAY WINDOW:
============================================================
🔴 Testing: Days since 20-day HIGH = 18
🔍 APPLYING FILTERS:
==================================================
📅 Cycle Year: Year1
📈 Records: 5,017 → 1,260 (25.1%)
==================================================
=== Historical Analysis: days_since_20d_high = 18 (Filtered: Year: Year1) ===
Total occurrences: 64
Date range: 2013-01-01 00:00:00 to 2025-06-14 00:00:00
Cycle Year breakdown: {'Year1': np.int64(64)}
Quarter breakdown: {1: np.int64(20), 2: np.int64(16), 3: np.int64(15), 4: np.int64(13)}
Month breakdown: {'December': np.int64(11), 'July': np.int64(10), 'January': np.int64(8), 'June': np.int64(7), 'February': np.int64(6), 'March': np.int64(6), 'September': np.int64(5), 'May': np.int64(5), 'April': np.int64(4), 'November': np.int64(2)}
--- 1-Day Forward Returns ---
Average return: 1.31%
Median return: 0.88%
Win rate: 61.9%
Best return: 31.60%
Worst return: -8.39%
Standard deviation: 5.39%
68% of returns fall between: -4.08% to 6.70%
--- 5-Day Forward Returns ---
Average return: 2.17%
Median return: 1.34%
Win rate: 61.9%
Best return: 31.34%
Worst return: -27.50%
Standard deviation: 10.42%
68% of returns fall between: -8.24% to 12.59%
--- 10-Day Forward Returns ---
Average return: 4.55%
Median return: 1.56%
Win rate: 54.8%
Best return: 43.09%
Worst return: -16.35%
Standard deviation: 12.96%
68% of returns fall between: -8.41% to 17.51%
--- 20-Day Forward Returns ---
Average return: 9.77%
Median return: 6.62%
Win rate: 59.7%
Best return: 71.45%
Worst return: -33.77%
Standard deviation: 22.31%
68% of returns fall between: -12.54% to 32.08%
🟢 Testing: Days since 20-day LOW = 9
🔍 APPLYING FILTERS:
==================================================
📅 Cycle Year: Year1
📈 Records: 5,017 → 1,260 (25.1%)
==================================================
=== Historical Analysis: days_since_20d_low = 9 (Filtered: Year: Year1) ===
Total occurrences: 38
Date range: 2013-01-10 00:00:00 to 2025-06-14 00:00:00
Cycle Year breakdown: {'Year1': np.int64(38)}
Quarter breakdown: {1: np.int64(9), 2: np.int64(11), 3: np.int64(10), 4: np.int64(8)}
Month breakdown: {'January': np.int64(5), 'July': np.int64(5), 'December': np.int64(5), 'April': np.int64(4), 'September': np.int64(4), 'June': np.int64(4), 'May': np.int64(3), 'March': np.int64(3), 'November': np.int64(2), 'August': np.int64(1), 'October': np.int64(1), 'February': np.int64(1)}
--- 1-Day Forward Returns ---
Average return: 0.55%
Median return: 0.19%
Win rate: 51.4%
Best return: 9.90%
Worst return: -5.93%
Standard deviation: 3.34%
68% of returns fall between: -2.79% to 3.89%
--- 5-Day Forward Returns ---
Average return: 2.35%
Median return: 2.03%
Win rate: 62.2%
Best return: 21.96%
Worst return: -15.00%
Standard deviation: 8.99%
68% of returns fall between: -6.64% to 11.34%
--- 10-Day Forward Returns ---
Average return: 5.80%
Median return: 4.56%
Win rate: 62.2%
Best return: 41.41%
Worst return: -26.26%
Standard deviation: 14.18%
68% of returns fall between: -8.38% to 19.98%
--- 20-Day Forward Returns ---
Average return: 12.15%
Median return: 4.86%
Win rate: 59.5%
Best return: 103.45%
Worst return: -28.80%
Standard deviation: 29.29%
68% of returns fall between: -17.14% to 41.43%
📊 SUMMARY COMPARISON TABLE (20-DAY WINDOW - Year: Year1):
================================================================================
Signal Type Occurrences 1D Avg 5D Avg 10D Avg 20D Avg 1D Win% 5D Win% 10D Win% 20D Win%
---------------------------------------------------------------------------------------------------------------
Days Since 20D High = 18 64 1.3% 2.2% 4.5% 9.8% 62% 62% 55% 60%
Days Since 20D Low = 9 38 0.5% 2.3% 5.8% 12.1% 51% 62% 62% 59%
================================================================================
⚡ QUICK INSIGHTS (20-DAY WINDOW - Year: Year1):
📈 20D High Signal (18d): 20-day avg 9.8% | Best: 71% | Worst: -34%
└─ 68% of returns fall between: -12.5% to +32.1% (±1 std dev)
📉 20D Low Signal (9d): 20-day avg 12.1% | Best: 103% | Worst: -29%
└─ 68% of returns fall between: -17.1% to +41.4% (±1 std dev)
================================================================================
📈 Creating original visualizations...
🔍 APPLYING FILTERS:
==================================================
📅 Cycle Year: Year1
📈 Records: 5,017 → 1,260 (25.1%)
==================================================
📈 CREATING INDIVIDUAL YEAR CHARTS FOR Year1: ============================================================ 🔴 High Signal Charts (20D High = 18 days): 📅 Creating individual charts for Year1: [np.int32(2013), np.int32(2017), np.int32(2021), np.int32(2025)]
🟢 Low Signal Charts (20D Low = 9 days): 📅 Creating individual charts for Year1: [np.int32(2013), np.int32(2017), np.int32(2021), np.int32(2025)]
Conversion successful!
Created: C:/Users/Chris/Python/format_csv.py
Before update data summary:
Date range: 2011-08-18 to 2025-06-14
Number of rows: 5017
CSV is already up to date.
After update (unchanged) data summary:
Date range: 2011-08-18 to 2025-06-14
Number of rows: 5017
Bitcoin performance after first all time high in 30 days (Year1)
================================================================
Date Bitcoin Close High Price Cycle Year Week Month 3 Month 6 Month Year
01/21/2013 16.52 16.98 Year1 13.01 81.60 619.19 414.77 4893.28
02/20/2013 30.00 30.07 Year1 4.37 133.00 291.67 242.83 1772.87
03/25/2013 75.11 80.00 Year1 39.40 98.38 33.68 64.28 677.22
11/06/2013 263.24 265.00 Year1 49.48 207.71 205.04 64.49 32.95
02/23/2017 1,188.11 1,193.92 Year1 5.80 -19.53 103.71 243.82 755.65
04/30/2017 1,350.21 1,356.00 Year1 15.09 63.20 98.53 327.48 584.50
06/06/2017 2,880.74 2,933.00 Year1 -6.17 -9.73 48.47 290.52 165.85
08/05/2017 3,263.62 3,339.66 Year1 18.12 31.05 118.98 175.74 115.48
10/12/2017 5,445.00 5,445.00 Year1 4.66 16.71 173.46 25.54 13.59
11/16/2017 7,846.96 7,976.79 Year1 1.81 144.53 20.95 8.00 -29.80
12/16/2017 19,187.78 19,377.00 Year1 -23.81 -29.08 -56.96 -65.36 -83.36
01/01/2021 29,402.64 29,700.00 Year1 38.31 12.72 99.74 19.16 62.49
02/08/2021 46,416.45 46,712.12 Year1 3.29 20.33 25.61 -3.89 -5.01
03/13/2021 61,165.19 61,781.83 Year1 -4.95 -2.18 -38.95 -24.15 -38.22
04/13/2021 63,564.48 63,769.00 Year1 -11.11 -21.82 -47.92 -13.92 -35.27
10/20/2021 65,990.31 67,016.50 Year1 -11.40 -11.91 -35.78 -38.15 -71.14
01/20/2025 102,141.00 109,356.00 Year1 -0.05 -5.38 -16.59 3.26 3.26
05/21/2025 109,682.00 110,730.00 Year1 -1.71 -3.84 -3.84 -3.84 -3.84
Average 7.45 39.21 91.06 96.14 489.47
Median 3.83 14.71 41.08 22.35 23.27
% Positive 61.1 55.6 66.7 66.7 61.1
Found 155 total ATHs to analyze
Analyzing 14-day pause ATHs...
Found 14 ATHs with 14-day pause
Bitcoin Forward Returns FROM Pause End - 14 day pauses (Year1)
==============================================================
ATH Date ATH Days End Date End Price Decline Cycle 1W 1W DD 1W Max 2W 2W DD 2W Max 1M 1M DD 1M Max 2M 2M DD 2M Max 3M 3M DD 3M Max 6M 6M DD 6M Max 1Y 1Y DD 1Y Max
04/10/2013 162.00 14 04/24/2013 149.00 -8.02 Year1 -21.64 -29.60 14.28 -24.05 -45.30 14.28 -13.62 -45.30 14.28 -32.61 -45.30 14.28 -41.62 -57.72 14.28 20.89 -57.72 22.10 237.05 -57.72 680.54
11/30/2013 1,119.80 14 12/14/2013 854.99 -23.65 Year1 -30.18 -55.30 1.75 -16.37 -55.30 1.75 -3.74 -55.30 16.38 -23.66 -55.30 16.38 -26.27 -55.30 16.38 -33.44 -60.26 16.38 -58.30 -67.84 16.38
03/10/2017 1,116.97 14 03/24/2017 929.06 -16.82 Year1 15.20 -4.06 16.35 28.16 -4.06 29.38 33.68 -4.06 34.79 143.71 -4.06 144.87 192.07 -4.06 220.75 317.03 -4.06 436.01 819.96 -4.06 2016.76
06/12/2017 2,667.06 14 06/26/2017 2,421.22 -9.22 Year1 5.34 -5.38 7.18 -4.04 -6.58 9.01 4.29 -24.42 21.34 79.91 -24.42 85.03 51.34 -24.42 105.68 503.79 -24.42 712.24 150.62 -24.42 712.24
09/02/2017 4,599.90 14 09/16/2017 3,678.93 -20.02 Year1 2.72 -5.87 12.06 17.59 -5.87 18.21 56.18 -5.87 58.92 98.26 -5.87 114.41 374.91 -5.87 387.48 124.66 -5.87 434.56 76.68 -5.87 434.56
12/17/2017 18,953.00 14 12/31/2017 13,880.00 -26.77 Year1 16.17 -7.77 24.17 -1.67 -7.78 24.17 -28.16 -33.56 24.17 -21.45 -57.34 24.17 -50.08 -57.34 24.17 -55.30 -58.40 24.17 -73.39 -77.51 24.17
01/08/2021 40,667.07 14 01/22/2021 32,992.06 -18.87 Year1 3.81 -11.64 17.06 16.15 -11.64 17.45 74.26 -11.64 76.87 64.77 -11.64 87.26 56.66 -11.64 96.70 -2.59 -13.31 96.70 6.36 -13.31 109.14
02/21/2021 57,492.91 14 03/07/2021 50,967.30 -11.35 Year1 15.79 -3.24 21.22 12.59 -3.24 21.22 13.83 -3.24 21.22 10.75 -7.78 27.33 -30.28 -41.01 27.33 -1.85 -43.89 27.33 -25.41 -43.89 35.38
03/13/2021 61,165.19 14 03/27/2021 55,839.42 -8.71 Year1 2.19 -2.08 7.64 7.03 -2.08 9.64 -3.16 -15.82 16.22 -29.60 -46.16 16.22 -43.41 -48.78 16.22 -19.58 -48.78 16.22 -16.07 -48.78 23.57
04/14/2021 62,986.09 14 04/28/2021 54,901.97 -12.83 Year1 4.75 -4.59 7.46 -10.05 -11.61 8.56 -34.99 -45.24 8.56 -36.80 -47.91 8.56 -28.10 -47.91 8.56 14.93 -47.91 22.07 -27.59 -47.91 25.68
10/20/2021 65,990.31 14 11/03/2021 62,930.72 -4.64 Year1 3.16 -4.48 9.64 -4.06 -7.20 9.64 -14.60 -18.07 9.64 -24.76 -33.31 9.64 -38.45 -47.64 9.64 -38.79 -47.64 9.64 -67.89 -72.04 9.64
11/10/2021 64,921.43 14 11/24/2021 57,185.06 -11.92 Year1 0.12 -6.78 3.95 -11.61 -26.61 3.95 -11.09 -26.61 3.95 -36.53 -40.54 3.95 -33.08 -42.38 3.95 -49.14 -55.58 3.95 -70.99 -72.93 3.95
01/20/2025 102,141.00 14 02/03/2025 101,457.00 -0.67 Year1 -3.93 -6.63 0.32 -5.60 -7.26 0.32 -10.69 -22.93 0.32 -17.35 -24.50 0.32 -7.04 -26.63 0.32 3.96 -26.63 10.36 3.96 -26.63 10.36
05/22/2025 111,673.28 14 06/05/2025 101,575.95 -9.04 Year1 4.29 -0.40 8.85 3.84 -0.40 8.85 3.84 -0.40 8.85 3.84 -0.40 8.85 3.84 -0.40 8.85 3.84 -0.40 8.85 3.84 -0.40 8.85
Average -13.04 1.27 -10.56 10.85 0.56 -13.92 12.60 4.72 -22.32 22.54 12.75 -28.89 40.09 27.18 -33.65 67.17 56.31 -35.35 131.47 68.49 -40.24 293.66
Median -11.63 3.49 -5.62 9.25 -2.85 -7.23 9.64 -3.45 -20.50 16.30 -19.40 -28.91 16.30 -27.19 -41.70 16.30 0.99 -45.77 22.09 -6.12 -45.90 24.93
% Positive 78.6 0.0 100.0 42.9 0.0 100.0 42.9 0.0 100.0 42.9 0.0 100.0 35.7 0.0 100.0 50.0 0.0 100.0 50.0 0.0 100.0
Breakdown by Pause Period:
14-day pause: 14 ATHs
Finished 2025-06-15 10:07:25.638944